/*insert into Photos (PhotoBlob) values(NULL)
Go
*/
select * from Photos
Go


INSERT INTO Photos(PhotoTitle,PhotoBlob)
SELECT 'Bino', BulkColumn from Openrowset( Bulk 'D:\user\ab_swim.jpg', Single_Blob) As PhotoBlob
GO

DELETE FROM Photos WHERE PhotoBlob IS NULL
GO

